package com.esd.crm.mapper;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;

import com.esd.crm.entity.Orders;
import com.esd.crm.entity.Product;

@Mapper
public interface ProductMapper {
	int deleteByPrimaryKey(Integer id);

	int deleteByCustomerId(Integer customerId);
	
	int deleteByOrderId(String orderId);
	
	int insert(Product record);

	int insertSelective(Product record);

	Product selectByPrimaryKey(Integer id);

	int updateByPrimaryKeySelective(Product record);

	int updateByPrimaryKeyWithBLOBs(Product record);

	int updateByPrimaryKey(Product record);

	List<Product> selectByParam(Map<String, Object> param);

	int selectByParamCount(Map<String, Object> param);

	BigDecimal selectSumAmout(Integer id);

	List<Orders> selectOrderNumbers(Map<String, Object> param);
	


}